package com.example.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.example.demo.user_infoModel;

public interface UserMapper {
	
	@Select("select * from user_info")
	public List<user_infoModel> getAllUser();
	
	@Select("select * from user_info where nickname = #{name} ")
	public List<user_infoModel> getUserByName(String name);
	
	@Options(useGeneratedKeys=true,keyColumn="id",keyProperty="id")
	public long insertUser();
}
